﻿CREATE TABLE [dbo].[ASMS_MaintenanceBillMaterial]
(
	[Id] uniqueidentifier NOT NULL PRIMARY KEY,
	[MaintenanceBillId] uniqueidentifier NOT NULL,
	[MaterialId] uniqueidentifier NOT NULL,
	[Count] int NOT NULL,
	[Price] money NOT NULL,
	[Amount] money NOT NULL,
	[Discount] money NOT NULL,
	[SalesCommission] money,
	[SalesCommissionType] int,
	[SalesCommissionAmount] money,
	[SalesManagerId] uniqueidentifier,
	[WarehouseId] uniqueidentifier,
	[Status] int NOT NULL
)
